IF NOT EXISTS ( SELECT 1 FROM dbo.sysobjects WHERE [name] = 'CaiGouOrder') 
	BEGIN
	CREATE TABLE [dbo].[CaiGouOrder] (
		Id int NOT NULL IDENTITY(1,1) ,
		OrderNo varchar(255) ,		
		JsonText text,
		PRIMARY KEY CLUSTERED ( [Id] )
	)
	END
GO
IF NOT EXISTS( SELECT 1 FROM sysindexes WHERE name=N'IX_CaiGouOrder_OrderNo')
BEGIN
   CREATE NONCLUSTERED INDEX IX_CaiGouOrder_OrderNo ON CaiGouOrder (OrderNo)
END
GO